
-- Master change script for the 0.9.5 GShield Release.

BEGIN TRY
	BEGIN TRAN
	
		-- Adds the TrimNonExactRatingResults bool (bit) column to the System table to support
		-- the new method in the ESRB ratings getting methods. Required for 0.9.5 and higher.
		ALTER TABLE dbo.System ADD TrimNonExactRatingResults BIT NOT NULL DEFAULT(1)
		
		-- Adds a new exception into the Exceptions table to ensure this process does not
		-- get picked up by the Sentinel service.
		INSERT INTO [GShield].[dbo].[Exceptions]
           ([Name], [DateAdded])
     VALUES
           ('CxSsGhhP0X4plzRKalPnTg==', GetDate())
		
	COMMIT TRAN
END TRY
BEGIN CATCH
	IF XACT_STATE() <> 0
		ROLLBACK TRAN;
END CATCH 